TTN Dashboard

Übersicht (aktuelle Werte)

DDS75-LB

dds75-lb-001

Distance

68.1 cm

Temperature

32.8 °C

dds75-lb-02

Distance

78.5 cm

Temperature

32.8 °C

dds75-lb-03

Distance

85.2 cm

Temperature

32.8 °C

dds75-lb-04

Distance

85.1 cm

Temperature

32.8 °C

dds75-lb-05

Distance

69.7 cm

Temperature

32.8 °C

dds75-lb-06

Distance

68.5 cm

Temperature

32.8 °C

dds75-lb-07

Distance

86.9 cm

Temperature

32.8 °C

dds75-lb-08

Distance

82.9 cm

Temperature

32.8 °C

dds75-lb-09

Distance

0 cm

Temperature

32.8 °C

dds75-lb-10

Distance

71.9 cm

Temperature

32.8 °C

dds75-lb-11

Distance

89.8 cm

Temperature

32.8 °C

dds75-lb-12

Distance

87.1 cm

Temperature

32.8 °C

dds75-lb-13

Distance

92.9 cm

Temperature

32.8 °C

dds75-lb-14

Distance

121.5 cm

Temperature

32.8 °C

dds75-lb-15

Distance

97.8 cm

Temperature

32.8 °C

dds75-lb-16

Distance

71.8 cm

Temperature

32.8 °C

dds75-lb-17

Distance

218.3 cm

Temperature

32.8 °C

dds75-lb-18

Distance

89.8 cm

Temperature

32.8 °C

dds75-lb-19

Distance

68 cm

Temperature

32.8 °C

dds75-lb-20

Distance

92.5 cm

Temperature

32.8 °C

dds75-lb-21

Distance

71.9 cm

Temperature

32.8 °C

PS-LB

ps-lb-01

Water

0 cm

ps-lb-02

Water

18.8 cm

ps-lb-03

Water

20.1 cm

ps-lb-04

Water

19.9 cm

ps-lb-05

Water

22.4 cm

ps-lb-06

Water

20.4 cm

ps-lb-07

Water

20 cm

ps-lb-08

Water

20.8 cm

ps-lb-09

Water

21.8 cm

ps-lb-10

Water

19.5 cm

ps-lb-11

Water

19.2 cm

ps-lb-12

Water

21.9 cm

ps-lb-13

Water

19.6 cm

ps-lb-14

Water

18.1 cm

ps-lb-15

Water

21.1 cm

ps-lb-16

Water

20.2 cm

ps-lb-17

Water

20.6 cm

ps-lb-18

Water

20 cm

ps-lb-19

Water

22.2 cm

ps-lb-20

Water

20.2 cm

ps-lb-21

Water

21.3 cm

Geräte-Tabelle

device_id	records	last_seen_utc	status
dds75-lb-001	155	2025-09-20 03:23:36Z	ok
dds75-lb-02	153	2025-09-20 03:27:28Z	ok
dds75-lb-03	155	2025-09-20 03:21:37Z	ok
dds75-lb-04	155	2025-09-20 03:24:34Z	ok
dds75-lb-05	155	2025-09-20 03:24:01Z	ok
dds75-lb-06	155	2025-09-20 03:28:17Z	ok
dds75-lb-07	154	2025-09-20 03:24:50Z	ok
dds75-lb-08	155	2025-09-20 03:24:36Z	ok
dds75-lb-09	155	2025-09-20 03:24:38Z	ok
dds75-lb-10	155	2025-09-20 03:25:22Z	ok
dds75-lb-11	155	2025-09-20 03:25:02Z	ok
dds75-lb-12	154	2025-09-20 03:26:04Z	ok
dds75-lb-13	155	2025-09-20 03:27:17Z	ok
dds75-lb-14	155	2025-09-20 03:22:08Z	ok
dds75-lb-15	155	2025-09-20 03:23:07Z	ok
dds75-lb-16	155	2025-09-20 03:20:47Z	ok
dds75-lb-17	155	2025-09-20 03:23:39Z	ok
dds75-lb-18	155	2025-09-20 03:21:17Z	ok
dds75-lb-19	155	2025-09-20 03:25:48Z	ok
dds75-lb-20	153	2025-09-20 03:23:36Z	ok
dds75-lb-21	155	2025-09-20 03:23:46Z	ok
ps-lb-01	404	2025-09-20 03:33:16Z	ok
ps-lb-02	462	2025-09-20 03:30:11Z	ok
ps-lb-03	463	2025-09-20 03:30:21Z	ok
ps-lb-04	460	2025-09-20 03:29:45Z	ok
ps-lb-05	461	2025-09-20 03:30:03Z	ok
ps-lb-06	443	2025-09-20 03:29:43Z	ok
ps-lb-07	460	2025-09-20 03:29:58Z	ok
ps-lb-08	462	2025-09-20 03:29:32Z	ok
ps-lb-09	463	2025-09-20 03:29:29Z	ok
ps-lb-10	463	2025-09-20 03:30:06Z	ok
ps-lb-11	464	2025-09-20 03:30:04Z	ok
ps-lb-12	463	2025-09-20 03:29:35Z	ok
ps-lb-13	2340	2025-09-20 03:32:04Z	ok
ps-lb-14	461	2025-09-20 03:30:10Z	ok
ps-lb-15	463	2025-09-20 03:30:00Z	ok
ps-lb-16	465	2025-09-20 03:30:01Z	ok
ps-lb-17	2583	2025-09-20 03:36:01Z	ok
ps-lb-18	379	2025-09-20 03:32:10Z	ok
ps-lb-19	483	2025-09-20 03:30:35Z	ok
ps-lb-20	486	2025-09-20 03:34:07Z	ok
ps-lb-21	318	2025-09-20 03:29:14Z	ok
sensecap-01	0	NaN	empty

Parquet: data/<device>.parquet • CSV: data/<device>.csv • NDJSON (raw): data/<device>_raw.ndjson

dds75-lb-001

received_at	f_port	battery	rssi	snr
2025-09-20 02:23:37.589431215+00:00	2	3.303	-118	-5.80
2025-09-20 02:43:37.383270384+00:00	2	3.303	-35	9.75
2025-09-20 03:03:37.158438341+00:00	2	3.303	-33	9.50
2025-09-20 03:23:36.914227510+00:00	2	3.303	-31	9.25

dds75-lb-02

received_at	f_port	battery	rssi	snr
2025-09-20 02:07:30.049939439+00:00	2	3.212	-39	10.25
2025-09-20 02:27:29.769636780+00:00	2	3.212	-118	-2.00
2025-09-20 02:47:29.480188467+00:00	2	3.212	-39	6.50
2025-09-20 03:07:29.218901930+00:00	2	3.212	-41	7.25
2025-09-20 03:27:28.932759584+00:00	2	3.212	-37	9.50

dds75-lb-03

received_at	f_port	battery	rssi	snr
2025-09-20 02:21:38.330963811+00:00	2	3.29	-121	-4.5
2025-09-20 02:41:38.092914865+00:00	2	3.29	-44	9.5
2025-09-20 03:01:37.880284157+00:00	2	3.29	-117	-1.5
2025-09-20 03:21:37.624197324+00:00	2	3.29	-42	9.0

dds75-lb-04

received_at	f_port	battery	rssi	snr
2025-09-20 02:04:35.633686567+00:00	2	3.256	-51	10.25
2025-09-20 02:24:35.372938054+00:00	2	3.256	-50	11.00
2025-09-20 02:44:35.154194676+00:00	2	3.256	-49	7.50
2025-09-20 03:04:34.919828574+00:00	2	3.256	-121	-5.50
2025-09-20 03:24:34.675325745+00:00	2	3.256	-49	9.25

dds75-lb-05

received_at	f_port	battery	rssi	snr
2025-09-20 02:24:02.573840526+00:00	2	3.301	-113	0.50
2025-09-20 02:44:02.344905032+00:00	2	3.301	-47	9.50
2025-09-20 03:04:02.127517477+00:00	2	3.301	-116	-2.25
2025-09-20 03:24:01.887292788+00:00	2	3.301	-45	10.25

dds75-lb-06

received_at	f_port	battery	rssi	snr
2025-09-20 02:08:18.813700496+00:00	2	3.343	-116	0.50
2025-09-20 02:28:18.592478283+00:00	2	3.343	-42	9.50
2025-09-20 02:48:18.357989689+00:00	2	3.343	-120	-4.00
2025-09-20 03:08:18.112313828+00:00	2	3.343	-43	8.75
2025-09-20 03:28:17.873296068+00:00	2	3.343	-119	-2.75

dds75-lb-07

received_at	f_port	battery	rssi	snr
2025-09-20 02:04:51.629944171+00:00	2	3.257	-36	9.75
2025-09-20 02:24:51.391971059+00:00	2	3.257	-35	9.75
2025-09-20 02:44:51.164678046+00:00	2	3.257	-36	9.25
2025-09-20 03:04:50.915285670+00:00	2	3.257	-118	-1.75
2025-09-20 03:24:50.704690395+00:00	2	3.257	-34	9.50

dds75-lb-08

received_at	f_port	battery	rssi	snr
2025-09-20 02:04:37.320346039+00:00	2	3.28	-112	4.25
2025-09-20 02:24:37.118043220+00:00	2	3.28	-115	0.75
2025-09-20 02:44:36.876889991+00:00	2	3.28	-35	8.00
2025-09-20 03:04:36.678495766+00:00	2	3.28	-109	5.50
2025-09-20 03:24:36.450106165+00:00	2	3.28	-116	-0.25

dds75-lb-09

received_at	f_port	battery	rssi	snr
2025-09-20 02:04:39.310682560+00:00	2	3.332	-49	7.25
2025-09-20 02:24:39.083659415+00:00	2	3.332	-46	7.75
2025-09-20 02:44:38.881434374+00:00	2	3.332	-47	7.50
2025-09-20 03:04:38.639105216+00:00	2	3.332	-48	9.25
2025-09-20 03:24:38.421794580+00:00	2	3.332	-51	9.25

dds75-lb-10

received_at	f_port	battery	rssi	snr
2025-09-20 02:05:22.920072165+00:00	2	3.357	-37	10.00
2025-09-20 02:25:22.720828302+00:00	2	3.357	-113	2.75
2025-09-20 02:45:22.462533493+00:00	2	3.357	-36	9.00
2025-09-20 03:05:22.232695599+00:00	2	3.357	-35	8.00
2025-09-20 03:25:22.014810473+00:00	2	3.357	-35	9.00

dds75-lb-11

received_at	f_port	battery	rssi	snr
2025-09-20 02:05:03.182489649+00:00	2	3.299	-37	9.50
2025-09-20 02:25:02.960042772+00:00	2	3.299	-35	7.50
2025-09-20 02:45:02.736083766+00:00	2	3.299	-122	-5.00
2025-09-20 03:05:02.523453004+00:00	2	3.299	-120	-4.25
2025-09-20 03:25:02.284483629+00:00	2	3.299	-39	9.75

dds75-lb-12

received_at	f_port	battery	rssi	snr
2025-09-20 02:06:05.610075198+00:00	2	3.314	-43	9.75
2025-09-20 02:26:05.361051010+00:00	2	3.314	-44	9.50
2025-09-20 02:46:05.132965991+00:00	2	3.314	-43	9.50
2025-09-20 03:06:04.882165759+00:00	2	3.314	-43	10.25
2025-09-20 03:26:04.624280486+00:00	2	3.314	-42	10.00

dds75-lb-13

received_at	f_port	battery	rssi	snr
2025-09-20 02:07:18.530323836+00:00	2	3.291	-37	10.75
2025-09-20 02:27:18.282775049+00:00	2	3.291	-35	9.00
2025-09-20 02:47:18.060554830+00:00	2	3.291	-38	9.75
2025-09-20 03:07:17.797416327+00:00	2	3.291	-115	1.50
2025-09-20 03:27:17.573971001+00:00	2	3.291	-35	8.75

dds75-lb-14

received_at	f_port	battery	rssi	snr
2025-09-20 02:22:09.243471083+00:00	2	3.286	-110	0.20
2025-09-20 02:42:09.061415779+00:00	2	3.286	-111	4.00
2025-09-20 03:02:08.823095542+00:00	2	3.286	-49	9.25
2025-09-20 03:22:08.592311120+00:00	2	3.286	-51	10.00

dds75-lb-15

received_at	f_port	battery	rssi	snr
2025-09-20 02:23:07.902522352+00:00	2	3.343	-37	10.00
2025-09-20 02:43:07.637892989+00:00	2	3.343	-110	4.50
2025-09-20 03:03:07.409302701+00:00	2	3.343	-31	7.75
2025-09-20 03:23:07.155784245+00:00	2	3.343	-33	8.50

dds75-lb-16

received_at	f_port	battery	rssi	snr
2025-09-20 02:20:48.319700088+00:00	2	3.324	-47	7.75
2025-09-20 02:40:48.085474550+00:00	2	3.324	-45	7.25
2025-09-20 03:00:47.861478111+00:00	2	3.324	-45	9.50
2025-09-20 03:20:47.618083052+00:00	2	3.324	-48	9.25

dds75-lb-17

received_at	f_port	battery	rssi	snr
2025-09-20 02:23:39.831388403+00:00	2	3.277	-109	1.80
2025-09-20 02:43:39.629053930+00:00	2	3.277	-36	9.50
2025-09-20 03:03:39.387230789+00:00	2	3.277	-120	-3.75
2025-09-20 03:23:39.170681828+00:00	2	3.277	-33	8.00

dds75-lb-18

received_at	f_port	battery	rssi	snr
2025-09-20 02:21:17.703120874+00:00	2	3.327	-50	7.5
2025-09-20 02:41:17.484312921+00:00	2	3.327	-53	7.5
2025-09-20 03:01:17.246423265+00:00	2	3.327	-50	9.0
2025-09-20 03:21:17.012398814+00:00	2	3.327	-53	9.0

dds75-lb-19

received_at	f_port	battery	rssi	snr
2025-09-20 02:05:48.980408217+00:00	2	3.341	-41	7.25
2025-09-20 02:25:48.739651427+00:00	2	3.341	-39	9.25
2025-09-20 02:45:48.498978525+00:00	2	3.341	-116	NaN
2025-09-20 03:05:48.272449916+00:00	2	3.341	-39	10.00
2025-09-20 03:25:48.022674888+00:00	2	3.341	-41	9.25

dds75-lb-20

received_at	f_port	battery	rssi	snr
2025-09-20 02:23:36.809102024+00:00	2	3.268	-122	-3.50
2025-09-20 02:43:36.623315467+00:00	2	3.268	-42	7.75
2025-09-20 03:03:36.392369341+00:00	2	3.268	-41	9.50
2025-09-20 03:23:36.171750596+00:00	2	3.268	-43	9.75

dds75-lb-21

received_at	f_port	battery	rssi	snr
2025-09-20 02:23:46.982259022+00:00	2	3.333	-108	3.20
2025-09-20 02:43:46.783388449+00:00	2	3.333	-31	8.75
2025-09-20 03:03:46.579009230+00:00	2	3.333	-35	10.00
2025-09-20 03:23:46.345158649+00:00	2	3.333	-30	8.25

ps-lb-01

received_at	f_port	battery	rssi	snr
2025-09-20 02:13:17.578920919+00:00	2	3.303	-29	10.75
2025-09-20 02:23:17.438581823+00:00	2	3.303	-113	-0.25
2025-09-20 02:33:17.325327167+00:00	2	3.303	-31	9.50
2025-09-20 02:43:17.206939104+00:00	2	3.303	-29	10.00
2025-09-20 02:53:17.131605157+00:00	2	3.303	-33	11.50
2025-09-20 03:03:16.971759124+00:00	2	3.303	-29	8.75
2025-09-20 03:13:16.847428355+00:00	2	3.303	-31	9.50
2025-09-20 03:23:16.754598947+00:00	2	3.303	-32	10.00
2025-09-20 03:33:16.630064732+00:00	2	3.303	-28	9.25

ps-lb-02

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:12.742178320+00:00	2	3.588	18.800	5.504	-120	-6.75
2025-09-20 02:20:12.585877123+00:00	2	3.588	18.788	5.503	-109	5.50
2025-09-20 02:30:12.502833712+00:00	2	3.588	18.800	5.504	-21	7.50
2025-09-20 02:40:12.386318469+00:00	2	3.588	18.800	5.504	-22	8.50
2025-09-20 02:50:12.270314186+00:00	2	3.588	18.800	5.504	-19	9.00
2025-09-20 03:00:12.133954832+00:00	2	3.588	18.800	5.504	-26	9.25
2025-09-20 03:10:12.019467603+00:00	2	3.588	18.788	5.503	-25	9.25
2025-09-20 03:20:11.902425871+00:00	2	3.588	18.788	5.503	-23	10.00
2025-09-20 03:30:11.772799034+00:00	2	3.588	18.788	5.503	-26	9.75

ps-lb-03

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:22.095880894+00:00	2	3.576	20.113	5.609	-116	-1.25
2025-09-20 02:20:21.945047569+00:00	2	3.582	20.113	5.609	-106	3.20
2025-09-20 02:30:21.870229915+00:00	2	3.582	20.113	5.609	-24	7.75
2025-09-20 02:40:21.743084636+00:00	2	3.582	20.113	5.609	-30	6.75
2025-09-20 02:50:21.641910010+00:00	2	3.582	20.113	5.609	-26	10.00
2025-09-20 03:00:21.540679197+00:00	2	3.582	20.113	5.609	-114	-0.50
2025-09-20 03:10:21.400372328+00:00	2	3.582	20.113	5.609	-115	0.50
2025-09-20 03:20:21.301655739+00:00	2	3.582	20.100	5.608	-27	9.75
2025-09-20 03:30:21.184701437+00:00	2	3.582	20.113	5.609	-27	8.75

ps-lb-04

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:46.309615164+00:00	2	3.582	19.937	5.595	-25	9.50
2025-09-20 02:19:46.162127955+00:00	2	3.582	19.937	5.595	-121	-4.80
2025-09-20 02:29:46.046522279+00:00	2	3.582	19.937	5.595	-121	-5.20
2025-09-20 02:39:45.963162094+00:00	2	3.582	19.937	5.595	-19	7.50
2025-09-20 02:49:45.850132820+00:00	2	3.576	19.937	5.595	-20	10.00
2025-09-20 02:59:45.725023614+00:00	2	3.582	19.925	5.594	-29	7.25
2025-09-20 03:09:45.584634865+00:00	2	3.582	19.925	5.594	-20	10.00
2025-09-20 03:19:45.488962407+00:00	2	3.582	19.925	5.594	-120	-4.50
2025-09-20 03:29:45.372923230+00:00	2	3.582	19.925	5.594	-24	9.25

ps-lb-05

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:04.430891332+00:00	2	3.588	22.413	5.793	-56	9.50
2025-09-20 02:20:04.297626698+00:00	2	3.588	22.413	5.793	-124	-4.80
2025-09-20 02:30:04.233129730+00:00	2	3.588	22.413	5.793	-55	10.00
2025-09-20 02:40:04.118953743+00:00	2	3.588	22.400	5.792	-54	9.75
2025-09-20 02:50:03.990563160+00:00	2	3.588	22.400	5.792	-57	10.50
2025-09-20 03:00:03.880880761+00:00	2	3.588	22.413	5.793	-56	10.50
2025-09-20 03:10:03.772613416+00:00	2	3.588	22.400	5.792	-56	10.00
2025-09-20 03:20:03.650998939+00:00	2	3.588	22.400	5.792	-59	7.50
2025-09-20 03:30:03.533335893+00:00	2	3.588	22.400	5.792	-55	9.50

ps-lb-06

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:44.139748782+00:00	2	3.576	20.375	5.630	-17	7.00
2025-09-20 02:19:43.988001276+00:00	2	3.576	20.375	5.630	-116	-3.50
2025-09-20 02:29:43.869671692+00:00	2	3.582	20.375	5.630	-114	2.20
2025-09-20 02:39:43.773306969+00:00	2	3.576	20.362	5.629	-17	10.75
2025-09-20 02:49:43.655256303+00:00	2	3.576	20.362	5.629	-17	10.00
2025-09-20 02:59:43.512792614+00:00	2	3.576	20.362	5.629	-20	9.75
2025-09-20 03:09:43.391655193+00:00	2	3.576	20.362	5.629	-17	10.25
2025-09-20 03:19:43.292347282+00:00	2	3.576	20.362	5.629	-19	7.25
2025-09-20 03:29:43.155921814+00:00	2	3.582	20.350	5.628	-17	7.75

ps-lb-07

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:59.710755740+00:00	2	3.552	20.037	5.603	-21	8.00
2025-09-20 02:19:59.540305934+00:00	2	3.552	20.037	5.603	-122	-8.20
2025-09-20 02:29:59.460888636+00:00	2	3.552	20.037	5.603	-22	9.25
2025-09-20 02:39:59.335671551+00:00	2	3.552	20.037	5.603	-21	10.75
2025-09-20 02:49:59.240601020+00:00	2	3.552	20.037	5.603	-22	9.25
2025-09-20 02:59:59.113739152+00:00	2	3.552	20.037	5.603	-23	10.25
2025-09-20 03:09:58.987379052+00:00	2	3.552	20.037	5.603	-120	-4.00
2025-09-20 03:19:58.862890339+00:00	2	3.552	20.037	5.603	-24	9.50
2025-09-20 03:29:58.746051480+00:00	2	3.552	20.037	5.603	-20	8.00

ps-lb-08

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:33.191767308+00:00	2	3.570	20.800	5.664	-42	9.00
2025-09-20 02:19:33.052886270+00:00	2	3.570	20.788	5.663	-112	3.00
2025-09-20 02:29:32.928224627+00:00	2	3.564	20.800	5.664	-108	3.80
2025-09-20 02:39:32.825581748+00:00	2	3.570	20.800	5.664	-118	-2.00
2025-09-20 02:49:32.748085126+00:00	2	3.570	20.788	5.663	-120	-6.25
2025-09-20 02:59:32.604203156+00:00	2	3.564	20.788	5.663	-43	9.50
2025-09-20 03:09:32.500759181+00:00	2	3.570	20.788	5.663	-41	9.75
2025-09-20 03:19:32.364149434+00:00	2	3.564	20.788	5.663	-43	7.25
2025-09-20 03:29:32.259690488+00:00	2	3.570	20.788	5.663	-118	-1.00

ps-lb-09

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:30.844083014+00:00	2	3.546	21.850	5.748	-39	7.25
2025-09-20 02:19:30.689086272+00:00	2	3.552	21.850	5.748	-112	-2.20
2025-09-20 02:29:30.571112372+00:00	2	3.552	21.850	5.748	-112	2.50
2025-09-20 02:39:30.496909527+00:00	2	3.552	21.850	5.748	-44	10.50
2025-09-20 02:49:30.359883457+00:00	2	3.552	21.850	5.748	-116	-1.00
2025-09-20 02:59:30.241622439+00:00	2	3.552	21.850	5.748	-39	9.75
2025-09-20 03:09:30.107760833+00:00	2	3.552	21.850	5.748	-122	-5.75
2025-09-20 03:19:29.992821080+00:00	2	3.552	21.850	5.748	-39	7.00
2025-09-20 03:29:29.881269242+00:00	2	3.552	21.837	5.747	-39	10.00

ps-lb-10

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:07.339938335+00:00	2	3.570	19.537	5.563	-43	9.50
2025-09-20 02:20:07.212473660+00:00	2	3.564	19.537	5.563	-39	8.00
2025-09-20 02:30:07.116163331+00:00	2	3.570	19.537	5.563	-43	9.50
2025-09-20 02:40:06.995459417+00:00	2	3.570	19.525	5.562	-43	10.00
2025-09-20 02:50:06.894575544+00:00	2	3.564	19.525	5.562	-44	10.50
2025-09-20 03:00:06.786572469+00:00	2	3.564	19.537	5.563	-45	9.75
2025-09-20 03:10:06.671825730+00:00	2	3.564	19.525	5.562	-41	8.25
2025-09-20 03:20:06.562589841+00:00	2	3.564	19.525	5.562	-41	10.25
2025-09-20 03:30:06.431912495+00:00	2	3.570	19.525	5.562	-44	9.75

ps-lb-11

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:05.220005319+00:00	2	3.564	19.25	5.54	-43	9.00
2025-09-20 02:20:05.077600043+00:00	2	3.564	19.25	5.54	-113	3.20
2025-09-20 02:30:04.999744878+00:00	2	3.564	19.25	5.54	-117	-1.50
2025-09-20 02:40:04.865077290+00:00	2	3.564	19.25	5.54	-43	7.25
2025-09-20 02:50:04.762513926+00:00	2	3.564	19.25	5.54	-43	7.25
2025-09-20 03:00:04.642875244+00:00	2	3.564	19.25	5.54	-45	10.75
2025-09-20 03:10:04.521919689+00:00	2	3.564	19.25	5.54	-44	9.50
2025-09-20 03:20:04.384434544+00:00	2	3.564	19.25	5.54	-44	9.25
2025-09-20 03:30:04.262969564+00:00	2	3.564	19.25	5.54	-47	6.25

ps-lb-12

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:36.110678312+00:00	2	3.594	21.875	5.750	-33	10.50
2025-09-20 02:19:35.961847275+00:00	2	3.594	21.875	5.750	-122	-7.00
2025-09-20 02:29:35.884112901+00:00	2	3.594	21.875	5.750	-32	10.00
2025-09-20 02:39:35.752653863+00:00	2	3.594	21.875	5.750	-32	7.50
2025-09-20 02:49:35.650235219+00:00	2	3.600	21.862	5.749	-31	9.50
2025-09-20 02:59:35.521349953+00:00	2	3.594	21.862	5.749	-33	7.00
2025-09-20 03:09:35.395257989+00:00	2	3.594	21.862	5.749	-30	9.75
2025-09-20 03:19:35.284561114+00:00	2	3.594	21.862	5.749	-32	8.50
2025-09-20 03:29:35.174853756+00:00	2	3.600	21.862	5.749	-31	7.75

ps-lb-13

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:32:04.890674905+00:00	2	3.582	19.563	5.565	-48	9.25
2025-09-20 03:02:04.517259843+00:00	2	3.582	19.563	5.565	-123	-7.00
2025-09-20 03:32:04.136550600+00:00	2	3.582	19.563	5.565	-47	7.50

ps-lb-14

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:11.380925803+00:00	2	3.57	18.112	5.449	-37	7.75
2025-09-20 02:20:11.231683870+00:00	2	3.57	18.100	5.448	-116	-3.00
2025-09-20 02:30:11.152834728+00:00	2	3.57	18.100	5.448	-38	9.25
2025-09-20 02:40:11.044200637+00:00	2	3.57	18.100	5.448	-38	9.25
2025-09-20 02:50:10.933279587+00:00	2	3.57	18.100	5.448	-41	9.50
2025-09-20 03:00:10.821031329+00:00	2	3.57	18.100	5.448	-41	10.00
2025-09-20 03:10:10.709262591+00:00	2	3.57	18.100	5.448	-39	10.25
2025-09-20 03:20:10.589855517+00:00	2	3.57	18.100	5.448	-120	-4.50
2025-09-20 03:30:10.483420478+00:00	2	3.57	18.100	5.448	-39	10.75

ps-lb-15

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:01.243911892+00:00	2	3.57	21.075	5.686	-38	9.25
2025-09-20 02:20:01.091689476+00:00	2	3.57	21.075	5.686	-120	-7.00
2025-09-20 02:30:00.965192595+00:00	2	3.57	21.075	5.686	-114	0.50
2025-09-20 02:40:00.862671954+00:00	2	3.57	21.075	5.686	-124	-8.00
2025-09-20 02:50:00.764356270+00:00	2	3.57	21.075	5.686	-38	9.50
2025-09-20 03:00:00.643689368+00:00	2	3.57	21.075	5.686	-41	10.00
2025-09-20 03:10:00.509422066+00:00	2	3.57	21.062	5.685	-41	10.00
2025-09-20 03:20:00.390295545+00:00	2	3.57	21.062	5.685	-39	7.25
2025-09-20 03:30:00.270704860+00:00	2	3.57	21.062	5.685	-43	6.75

ps-lb-16

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:02.859587807+00:00	2	3.564	20.175	5.614	-39	7.50
2025-09-20 02:20:02.694699053+00:00	2	3.564	20.188	5.615	-114	1.20
2025-09-20 02:30:02.639706921+00:00	2	3.564	20.175	5.614	-42	9.75
2025-09-20 02:40:02.513187490+00:00	2	3.564	20.175	5.614	-39	8.00
2025-09-20 02:50:02.390354414+00:00	2	3.564	20.188	5.615	-118	-2.00
2025-09-20 03:00:02.253473456+00:00	2	3.564	20.175	5.614	-39	9.00
2025-09-20 03:10:02.138792125+00:00	2	3.564	20.175	5.614	-119	-2.75
2025-09-20 03:20:02.023209132+00:00	2	3.564	20.175	5.614	-38	8.00
2025-09-20 03:30:01.918444928+00:00	2	3.564	20.175	5.614	-118	-2.00

ps-lb-17

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 03:25:01.262097004+00:00	2	3.552	20.637	5.651	-57	9.25
2025-09-20 03:26:01.252669508+00:00	2	3.546	20.637	5.651	-56	6.75
2025-09-20 03:27:01.250498759+00:00	2	3.552	20.637	5.651	-57	10.25
2025-09-20 03:28:01.234155171+00:00	2	3.546	20.637	5.651	-56	10.00
2025-09-20 03:29:01.231784595+00:00	2	3.546	20.637	5.651	-123	-7.75
2025-09-20 03:30:01.223768152+00:00	2	3.546	20.637	5.651	-55	8.00
2025-09-20 03:31:01.223442448+00:00	2	3.546	20.637	5.651	-57	9.75
2025-09-20 03:32:01.193145866+00:00	2	3.552	20.637	5.651	-59	10.00
2025-09-20 03:33:01.197744919+00:00	2	3.546	20.637	5.651	-55	9.50
2025-09-20 03:34:01.165613402+00:00	2	3.546	20.637	5.651	-55	6.50
2025-09-20 03:35:01.176966196+00:00	2	3.546	20.637	5.651	-54	8.75
2025-09-20 03:36:01.149615572+00:00	2	3.546	20.637	5.651	-55	9.50

ps-lb-18

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:12:11.794870388+00:00	2	3.582	20.037	5.603	-119	-3.25
2025-09-20 02:22:11.633617253+00:00	2	3.582	20.037	5.603	-109	2.00
2025-09-20 02:32:11.542055419+00:00	2	3.576	20.037	5.603	-29	9.75
2025-09-20 02:42:11.413022230+00:00	2	3.582	20.037	5.603	-31	11.25
2025-09-20 02:52:11.310959371+00:00	2	3.576	20.037	5.603	-31	10.50
2025-09-20 03:02:11.191793314+00:00	2	3.576	20.037	5.603	-29	7.00
2025-09-20 03:12:11.054399723+00:00	2	3.576	20.037	5.603	-26	8.75
2025-09-20 03:22:10.957131656+00:00	2	3.576	20.025	5.602	-30	9.50
2025-09-20 03:32:10.821528592+00:00	2	3.582	20.037	5.603	-29	11.00

ps-lb-19

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:10:36.171459489+00:00	2	3.534	22.188	5.775	-36	7.50
2025-09-20 02:20:36.081332466+00:00	2	3.534	22.188	5.775	-116	-1.25
2025-09-20 02:30:35.940620010+00:00	2	3.534	22.175	5.774	-33	10.25
2025-09-20 02:40:35.805183218+00:00	2	3.534	22.175	5.774	-35	7.00
2025-09-20 02:50:35.703400385+00:00	2	3.534	22.188	5.775	-35	9.75
2025-09-20 03:00:35.571571048+00:00	2	3.534	22.188	5.775	-33	7.75
2025-09-20 03:10:35.445576236+00:00	2	3.534	22.175	5.774	-123	-6.25
2025-09-20 03:20:35.345839632+00:00	2	3.534	22.175	5.774	-37	10.00
2025-09-20 03:30:35.216324520+00:00	2	3.534	22.175	5.774	-36	10.00

ps-lb-20

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:14:07.953592003+00:00	2	3.594	19.825	5.586	-115	0.75
2025-09-20 02:24:07.804257833+00:00	2	3.594	19.750	5.580	-117	-2.00
2025-09-20 02:34:07.750645797+00:00	2	3.594	19.725	5.578	-119	-3.00
2025-09-20 02:44:07.603581649+00:00	2	3.594	19.850	5.588	-43	10.25
2025-09-20 02:54:07.510961834+00:00	2	3.594	20.012	5.601	-41	9.75
2025-09-20 03:04:07.371817838+00:00	2	3.594	20.037	5.603	-43	9.50
2025-09-20 03:14:07.245801303+00:00	2	3.594	20.113	5.609	-42	9.00
2025-09-20 03:24:07.134900810+00:00	2	3.594	20.188	5.615	-42	9.50
2025-09-20 03:34:07.032017736+00:00	2	3.594	20.163	5.613	-42	10.00

ps-lb-21

received_at	f_port	battery	water_cm	idc_input_ma	rssi	snr
2025-09-20 02:09:14.980643291+00:00	2	3.582	21.350	5.708	-35	10.00
2025-09-20 02:19:14.836057088+00:00	2	3.582	21.350	5.708	-114	3.00
2025-09-20 02:29:14.734585670+00:00	2	3.582	21.350	5.708	-115	-0.50
2025-09-20 02:39:14.665891219+00:00	2	3.582	21.350	5.708	-35	10.50
2025-09-20 02:49:14.546814400+00:00	2	3.582	21.337	5.707	-115	-6.50
2025-09-20 02:59:14.461772937+00:00	2	3.582	21.337	5.707	-35	9.75
2025-09-20 03:09:14.341443786+00:00	2	3.582	21.337	5.707	-35	10.75
2025-09-20 03:19:14.222025920+00:00	2	3.582	21.350	5.708	-35	9.75
2025-09-20 03:29:14.120152708+00:00	2	3.582	21.337	5.707	-115	1.50

sensecap-01

no recent data

Allgemeine Formate im Repo

NDJSON (Newline Delimited JSON)

Jede Zeile ein JSON-Objekt → ideal für Streaming & APIs.
Direkt auswertbar mit jq, pandas.read_json(..., lines=True), jsonlite::stream_in().

# bash / jq
head -n 3 data/<device>_raw.ndjson | jq .
# Python / pandas
import pandas as pd
df = pd.read_json("data/<device>_raw.ndjson", lines=True)

Hinweis: data/<device>_raw.ndjson enthält die rohen TTN-Storage-Antworten pro Pull (optional append/snapshot).

Parquet

Spaltenorientiert, binär, sehr kompakt & schnell.
Für Analysen/Abfragen optimiert – Standard in Spark, DuckDB, BigQuery etc.

# Python / pandas
import pandas as pd
df = pd.read_parquet("data/<device>.parquet")

Typischer Workflow: Rohdaten zuerst als NDJSON persistieren → für Analyse/Archiv in Parquet konvertieren.

CSV

Mensch- & toollesbar, maximal interoperabel (Excel, R, GIS, Shell).
Wird vom Script zusätzlich zu Parquet erzeugt: data/<device>.csv.

# Python / pandas (mit Timestamps)
import pandas as pd
df = pd.read_csv("data/<device>.csv", parse_dates=["received_at"])
# Schnellblick (Shell)
head -n 3 data/<device>.csv

Hinweis: Das Script **liest bevorzugt Parquet** (Performance). CSV dient als offenes Austauschformat und Fallback.

Sensoren & Felder

Sensor	Wichtige Felder
DDS75-LB (`dds75-lb-*.parquet`)	`distance_cm` (bzw. `Distance_mm`), `temperature`, `battery`, Flags: `interrupt_flag`, `sensor_flag`
PS-LB (`burgwald-ps-lb-*.parquet`)	`water_cm` bzw. `pressure_kpa`/`pressure_mpa`, zusätzlich `idc_input_ma`, `vdc_input_v`, `battery`, digitale Eingänge
SenseCAP (`burgwald-sensecap-*.parquet`)	`temperature`, `humidity`, `pressure_hpa`, `illumination`, ggf. `uv_index`, `wind_speed`, `wind_dir`, `rainfall`

Hinweis: Das Dashboard gruppiert Devices automatisch nach Sensor-Typ und zeigt Betriebswerte (Battery/RSSI/SNR/Power) in einem Sammel-Diagramm.

TTN Dashboard – Grouped by Sensor Type

Übersicht (aktuelle Werte)

DDS75-LB

dds75-lb-001

dds75-lb-02

dds75-lb-03

dds75-lb-04

dds75-lb-05

dds75-lb-06

dds75-lb-07

dds75-lb-08

dds75-lb-09

dds75-lb-10

dds75-lb-11

dds75-lb-12

dds75-lb-13

dds75-lb-14

dds75-lb-15

dds75-lb-16

dds75-lb-17

dds75-lb-18

dds75-lb-19

dds75-lb-20

dds75-lb-21

PS-LB

ps-lb-01

ps-lb-02

ps-lb-03

ps-lb-04

ps-lb-05

ps-lb-06

ps-lb-07

ps-lb-08

ps-lb-09

ps-lb-10

ps-lb-11

ps-lb-12

ps-lb-13

ps-lb-14

ps-lb-15

ps-lb-16

ps-lb-17

ps-lb-18

ps-lb-19

ps-lb-20

ps-lb-21

Geräte-Tabelle

DDS75-LB

dds75-lb-001

dds75-lb-02

dds75-lb-03

dds75-lb-04

dds75-lb-05

dds75-lb-06

dds75-lb-07

dds75-lb-08

dds75-lb-09

dds75-lb-10

dds75-lb-11

dds75-lb-12

dds75-lb-13

dds75-lb-14

dds75-lb-15

dds75-lb-16

dds75-lb-17

dds75-lb-18

dds75-lb-19

dds75-lb-20

dds75-lb-21

PS-LB

ps-lb-01

ps-lb-02

ps-lb-03

ps-lb-04

ps-lb-05

ps-lb-06

ps-lb-07

ps-lb-08

ps-lb-09

ps-lb-10